NUMERIC Columns

FLOOR(<column>) - returns the largest integer less than or equal to each record.

CEIL(<column>) - returns the smallest integer greater than or equal to each record.

INT(<column>) - return the integer or whole number part of each record as an INTEGER column. The number will be rounded to a whole number, eg: 1.7 will be returned as 2.

BIGINT(<column>) - return the integer or whole number part of each record as a BIGINT column. The number will be rounded to a whole number, eg: 1.7 will be returned as 2.

RAND(<number>) - produces a random number between 0 and the value of each record in the column.

ABS(<column>) - removes the sign from each record.

SQRT(<column>) - returns the square root of each record.

SGN(<column>) - return the sign of each record, - 1 for negative numbers, +1 for positive numbers or 0.

NORMALISED(<column>) - returns the normalized value of each record in the column, defined as the difference between each value and the average value, divided by the standard deviation

CUMUL(<column>) - returns the cumulative value of all column records or the running balance

LOG(<column>) - returns the natural logarithm of the column records

LOG10(<column>) - returns the base 10 logarithm of the column records

EXP(<column>) - returns the exponential of each column record

POWER(<column>,<number>) - returns each column record raised to the power of <number>

STRING(<column>) - returns the record as a string

• NSQL Functions Overview
  • NSQL Functions A to Z
  • NSQL Intrinsic Functions
  • DATE Columns
  • Distance Calculations
  • Miscellaneous Functions
  • NUMERIC Columns
  • Text Columns
  • TIME Columns